Import all objects from a database
1) Select the 'File' menu and select 'Get External Data'. (A submenu appears.)
2) Select 'Import...' from the submenu. (The Import dialog box appears.)
3) Make sure 'Microsoft Access (*.mdb;*.mdw;)' is selected in the 'Files of type' drop-down list box.
4) Select the drive where the source database (the database from which to retrieve objects) is located from the 'Look in' drop-down list.
5) Select the folder that contains the source database from the 'Look in' list box. (The database file is displayed.)
NOTE: If the database file is in a subfolder, continue selecting folders until the desired database file is displayed.
6) Select the database file. (The file is highlighted.)
7) Choose the 'Import' button. (The Import Objects dialog box appears.)
8) If the source database has a database password:
a) Enter the password in the 'Password' box.
b) Choose 'OK'.
9) Choose the 'Tables' tab in the 'Import Objects' dialog box.
10) Choose the 'Select All' button. (All the tables are highlighted.)
11) (Optional) Specify importing options with the 'Options' button:
a) Choose the 'Options' button. (The Import Objects dialog box expands to display importing options.)
b) Do one or more of the following:
1] To include relationships defined in the source database, check the 'Relationships' check box in the 'Import' group.
2] To include custom toolbars defined in the source database, check the 'Toolbars' check box.
NOTE: If a custom toolbar in the source database has the same name as a custom toolbar in the destination database, that toolbar will not be imported.
3] To include all the importing specifications, check the 'Import/Export Spec' check box.
4] To import the tables' definitions AND the data they contain, select the 'Definitions and Data' radio button in the 'Import Tables' group.
5] To import just the selected tables' definitions (NOT the data they contain), select the 'Definition Only' radio button in the 'Import Tables' group.
12) Choose the 'Queries' tab.
13) Choose the 'Select All' button. (All the queries are highlighted.)
14) (Optional) To import select queries as tables:
a) Choose the 'Options' button. (The Import Objects dialog box expands to display importing options.)
b) Select the 'As Tables' radio button in the 'Import Queries' group.
NOTE: Action queries remain as queries no matter which option is selected.
15) Choose the 'Forms' tab.
16) Choose the 'Select All' button. (All the forms are highlighted.)
17) Repeat steps 15) through 16) for reports, macros, and modules.
18) Choose 'OK' to import all of the selected objects.